/**
 *	数据库单据操作记录-flowlog
 *	开发者：雨中磐石
 *	地址：www.rockoa.com
 *	日期：2023-07-19
 */

package com.framework.Module.flow.flowlog;

import com.framework.Table.Table;
import com.framerock.db.DBConn;
import com.framerock.baselib.Rock;

public class Tableflowlog extends  Table{
	
    protected void initTable() {
        this.tablename   = "flowlog";
        this.tablenamesm = "单据操作记录";

        this.flowsetMap  = Rock.getMap(new String[]{
                "type", "系统",
                "sort", "912",
                "isxt", "2",
        });

        this.addfields("name", "varchar(50)", "", "操作名称", new String[]{
                "isss","1",
        });
        this.addfields("table", "varchar(50)", "", "对应表", new String[]{

        });
        this.addfields("mid", "int(11)", "0", "单据Id", new String[]{

        });
        this.addfields("status", "tinyint(4)", "0", "状态值", new String[]{
                "islb","1"
        });
        this.addfields("statusname", "varchar(50)", "", "状态名");
        this.addfields("statuscolor", "varchar(50)", "", "状态颜色", new String[]{
                "islb","0"
        });
        this.addfields("courseid", "int(11)", "0", "步骤Id", new String[]{
                "islb","0"
        });
        this.addfields("checkname", "varchar(50)", "0", "审核人");
        this.addfields("checkid", "int(11)", "0", "审核人ID", new String[]{
                "islb","0"
        });
        this.addfields("cid", "int(11)", "0", "对应单位");
        this.addfields("modeid", "int(11)", "0", "对应模块");
        this.addfields("explain", "varchar(500)", "", "说明");
        this.addfields("optdt", "datetime", null, "操作时间");
        this.addfields("qmimg", "varchar(300)", "", "签名", new String[]{
                "fieldstype","uploadimg"
        });
        this.addfields("filecont", "varchar(300)", "", "相关文件", new String[]{
                "fieldstype","uploadfile",
                "islb", "1"
        });
        this.addfields("valid", "tinyint(1)", "1", "有效");

        this.addfields("cid", "KEY", "`cid`", "单位ID");
        this.addfields("table_mid", "KEY", "`table`,`mid`", "对应表索引");
    }
}
